package com.example.function.integration.mapper;

import com.example.function.integration.entity.HuanengImageDataEntity;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @description:金条影像件实体
 * @className:CrlArchiveInfoExtendMapper
 * @author:ext.fengcheng
 * @date:2023/9/18 17:46
 */
public interface CrlArchiveInfoExtendMapper {
    @Select("select ai.file_type as fileType, ai.archive_file_name as archiveFileName, ai.archive_url as archiveUrl " +
            "from crl_archive_info ai " +
            "where ai.tenant_id = #{tenantId,jdbcType=VARCHAR} " +
            "and ai.business_no in(${businessNo}) " +
            "order by ai.id")
    List<HuanengImageDataEntity> getHuanengImageData(@Param("tenantId") String tenantId,
                                                     @Param("businessNo") String businessNo);
}
